Loading data for organizational profitability

The Management General Ledger (MGTGL) table stores data that is typically not included in the General Ledger (GL), including FTP and similar adjusting entries for management reporting purposes. The Cost Allocation Engine posts the following to the MGTGL table:

• Allocated expense entries to the target departments, by allocation ID
• Summarized cost allocation offsets to the allocating departments

The Load Data tab on the Organizational Profitability page allows you to populate the MGTGL reporting table by copying data from an existing GL table.

NOTE: This process runs automatically when the Financial Reporting Administrator marks a month as complete. Loading the MGTGL table manually is only necessary if you want to run allocations before the GL is complete; for example, if you want to test allocations, or if GL is complete but the Administrator is not ready to release results for financial reports.

Populating the management GL (MGTGL) table

To populate the MGTGL table:

1. On the FI Command Center home page, click Organizational Profitability.

   

   Click image to view full size

2. Click the Load Data tab, if it is not already selected.
3. In the Populate MGTGL list, select the source GL reporting table to use to populate the target MGTGL table, and click Process.
4. Review the confirmation message, then click OK.